#!/Library/Frameworks/Python.framework/Versions/3.7/bin/python3.7
# -*- coding: utf-8 -*- 例如，可添加# -*- coding: utf-8 -*-

from openpyxl import load_workbook

table_name = "/Users/not_every/AllProjects/gitee/awesome-webapp/www/huiding/maintain/总表对应字段"
workbook = load_workbook('%s.xlsx' % (table_name))
print(workbook.sheetnames)
sheet = workbook["修改后总表对应字段"]

title = '';
for index,cell in enumerate(sheet):
    # print(cell[0].value)
    # print(cell[1].value)

    # print('content[i]['+ str(index) +'] = String.valueOf(mapSub.get("'+ str(cell[0].value) +'"));')

    title += '"' + str(cell[1].value) + '", '
    print(title)

print("over...")
